package com.itheima.dao;

import com.github.pagehelper.Page;
import com.itheima.pojo.Member;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface MemberDao {
    public List<Member> findAll();
    public Page<Member> selectByCondition(String queryString);
    public void add(Member member);
    public void deleteById(Integer id);
    public Member findById(Integer id);
    public Member findByTelephone(String telephone);
    public void edit(Member member);
    public Integer findMemberCountBeforeDate(String date);
    public Integer findMemberCountByDate(String date);
    public Integer findMemberCountAfterDate(String date);
    //public Integer findMemberCountAfterDate(Map weekdate);
    public Integer findMemberTotalCount();

    Long findCountBefore18AgeBoy(Date age18);

    Long findCountBefore18AgeGirl(Date age18);


    Long findCount45AfterAgeBoy(Date age45);

    Long findCount45AfterAgeGirl(Date age45);

    Long findCount18to30AgeBoy(Map map18to30);

    Long findCount18to30AgeGirl(Map map18to30);

    Long findCount30to45AgeBoy(Map map30to45);

    Long findCount30to45AgeGirl(Map map30to45);
}
